'use strict'

const pg = require('pg')

let psql = new pg.Pool({
    host:'127.0.0.1',
    port:5432,
    user:'thb',
    password:'123456789',
    database:'thb',
    //最大客户端连接数量
    max:8
})

;(async() =>{
    let sqltext = `insert into `
            +`content(id, title, detail, add_time, update_time)`
            +`values ($1, $2, $3, $4, $5)`
    
    let tm = Date.now()

    let ret = await psql.query(sqltext, [
        `${tm}`,
        `${Math.random()}`,
        '测试内容',
        tm,
        tm
    ])

    let ret2 = await psql.query(`select * from content`)

    psql.end()

    console.log(ret, ret2);

})();
